Learn and practice Aptitude questions and answers with explanation for interview, competitive exam (Pariksha Corner )

KPTCL Assistant Exam (Mescom) SLOT1 2017+UnSolved



Saturday, January 4, 2020

Deen Dayal Upadhyaya Grameen Kaushalya Yojana is a:

Deen Dayal Upadhyaya Grameen Kaushalya Yojana is a:
ASocial security scheme for rural households
BScheme to provide `right to work` for people falling below poverty line
CPlacement linked skill development scheme for rural poor youth
DNational rural livelihood mission
View Answer

Where in our body can we find "Hammer & Anvil"?

Where in our body can we find "Hammer & Anvil"?
AKnee
BBrain
CShoulder
DEar
View Answer

You want to calculate the payment for a loan amount of INR 20,000 at 10% interest rate for a period of 2 years.

You want to calculate the payment for a loan amount of INR 20,000 at 10% interest rate for a period of 2 years. Which of the following excel formula would you use in cell E2 assuming the loan is compounded monthly?
A"=PMT(A2/C2,B2*C2,D2)"
B"=NPER(A2/C2,B2*C2,D2)"
C"=RATE(A2/C2,B2*C2,D2)"
D"=PV(A2/C2,B2*C2,D2)"
View Answer

The MS­Excel 2010 worksheet in the following figure contains large quantities ofdata.

The MS­Excel 2010 worksheet in the following figure contains large quantities of data. You want to print only the data in the range A1 through D19. How would you achieve this?

A Select the cells A1 through D19, click File, and then click Print. In the Printpanel, under Settings, click Print Selection and click the Print button.
BSelect the cells A1 through D19, click File, and then click Print. In the Printpanel, under Settings, click Print Active Sheets and click the Print button.
C Select the cells D1 through D19, click File, and then click Print. In the Printpanel, under Settings, click PrintSelection and click the Print button.
D Select the cells D1 through D19, click File, and then click Print. In the Printpanel, under Settings, click Print Active Sheets and click the Print button.
View Answer

You want to find out the year­ wise total sales on different regions.

You want to find out the year­ wise total sales on different regions. Which of the following should you perform in MS­Excel 2010 to achieve the same?
A Sort the Year field from smallest to largest. Then, select the Data tab and click the Subtotal command to use it.
B Sort the State field in ascending order. Then, select the Data tab and use the Group command to use it.
C Sort the Year field from smallest to largest. Then, select the Data tab and clickthe Consolidate command to use it.
DSort the State field in ascending order. Then, select the Data tab and click the Subtotal command to use it.
View Answer

Categories